<?php

class FIN_CountryBean {
	
	public function __construct() {
	// contructor function
	}
	
	/*returns the whole active left sided country table
	 */ 
	public static function get_all_country($db) {
		
    	$strSQL = sprintf("SELECT * FROM ".TBL_COUNTRY);
    	return $db->get_results($strSQL);
    }
	public static function get_country_byId($db,$id) {
		
    	$strSQL = sprintf("SELECT * FROM ".TBL_COUNTRY." WHERE countries_id = '$id'");
    	return $db->get_row($strSQL);
    }
	
}
?>
